package com.example.back.dao.records;

import com.example.back.bean.records.PlayLog;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.Date;
import java.util.List;

@Mapper
public interface PlayLogDao {

    @Select("select tableId,creatorId,players,scores,tableMsg,overTime,createTime from playLog_table order by overTime desc")
    List<PlayLog> getAllPlayRecords();

    @Delete("delete from playLog_table where createTime < #{date}")
    void delFiveDaysTableLogs(Date date);
}
